/*
CREATE TABLE "base_de_library" (
  "sequence_nbr" varchar PRIMARY KEY NOT NULL,
  "library_code" varchar,
  "library_name" varchar,
  "library_major" varchar,
  "sort_no" decimal,
  "sort" decimal,
  "release_date" varchar,
  "ss_province" varchar,
  "ss_city" varchar,
  "remark" varchar,
  "de_standard_id" varchar,
  "rec_user_code" varchar,
  "rec_status" varchar DEFAULT ('A'),
  "rec_date" varchar,
  "extend1" varchar,
  "extend2" varchar,
  "extend3" varchar,
  "description" varchar
);
*/

use rbatis::crud;
use serde::{Deserialize, Serialize};

#[derive(Debug, Serialize, Deserialize)]
pub struct BaseDeLibrary {
    pub sequence_nbr: String,
    pub library_code: Option<String>,
    pub library_name: Option<String>,
    pub library_major: Option<String>,
    pub sort_no: Option<f64>,
    pub sort: Option<f64>,
    pub release_date: Option<String>,
    pub ss_province: Option<String>,
    pub ss_city: Option<String>,
    pub remark: Option<String>,
    pub de_standard_id: Option<String>,
    pub rec_user_code: Option<String>,
    pub rec_status: Option<String>,
    pub rec_date: Option<String>,
    pub extend1: Option<String>,
    pub extend2: Option<String>,
    pub extend3: Option<String>,
    pub description: Option<String>,
}
crud!(BaseDeLibrary {}, "base_de_library");
